UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'USMA3MeAXVi0A72TE2WoOCdLouc80X4z/6a+JnpBM3w='
WHERE
key_id = 'e80d234d1d56bc5e1baf790d3314049b9a382f9b3d766ba2d66885e9d7b98e2b'
AND (
token = 'USMA3MeAXVi0A72TE2WoOCdLouc80X4z/6a+JnpBM3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)