UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sHea8OSGGPdMf7q0zhSfpQk3hQKK/HQaRBR97SWEs8A='
WHERE
key_id = '6930bcce28410da40144c4d2a516ddfb478f5513767f751abf73456afbfa1985'
AND (
token = 'sHea8OSGGPdMf7q0zhSfpQk3hQKK/HQaRBR97SWEs8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)