UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVQVi95GhAWDMEqijFNtMI6jtv8e8Wie7G/DR65Uego='
WHERE
key_id = 'd24212bf6b27db4665ae0133068ac0edf425a65d4b8d2212cfb927d9e648238f'
AND (
token = 'RVQVi95GhAWDMEqijFNtMI6jtv8e8Wie7G/DR65Uego='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)