UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HX7fid0E8G3mYGKQRDmbrbWC6OryQcg0AEWwway1mM='
WHERE
key_id = '49367ddbc1c0715c7679c0ffcdb4c1ef77268f5a8759766f8cfa2fb2084a3e8a'
AND (
token = '7HX7fid0E8G3mYGKQRDmbrbWC6OryQcg0AEWwway1mM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)