UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOjbNPyabdbAWRnnTLKVTI78CyUSap977oFuyvVi93E='
WHERE
key_id = 'f2ba322df01b32bcff320d01e0a0c2ba1c31eadf9e4282e53a4f2a25b8530758'
AND (
token = 'cOjbNPyabdbAWRnnTLKVTI78CyUSap977oFuyvVi93E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)