UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ctCnU44MZ/ef2VSXklYs4VPdBwBM7o6vGNujeHL3qbY='
WHERE
key_id = '672801db32a3dba8f0052cd947fe4706effd0457a2cd0f717b4401fc665a3def'
AND (
token = 'ctCnU44MZ/ef2VSXklYs4VPdBwBM7o6vGNujeHL3qbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)