UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+6zSoUcm6y8hBIiaT4V8JkG81QPQWVZklokT1768RI='
WHERE
key_id = '400c28cecda33c321acc3d5f7b6f6a234103e349d90ea9d852db11e69ff88516'
AND (
token = 'X+6zSoUcm6y8hBIiaT4V8JkG81QPQWVZklokT1768RI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)