UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFV6br7TKYd1b0AIAcl5I9GcZ/NCwdeJLKMOIku9QKk='
WHERE
key_id = 'd0f503c844ee09933997d7da24053ef974b8ef9d38f2478ee22ed2868e541b8d'
AND (
token = 'HFV6br7TKYd1b0AIAcl5I9GcZ/NCwdeJLKMOIku9QKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)