UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIODHrw7NXnkUuEwga9ZjMwc9xH+xu6LVZXrkfHkss0='
WHERE
key_id = 'e54aef6323bc8caee6b3f85a886cedfe22d04662a1f2b482e9b97cba66eaba29'
AND (
token = 'sIODHrw7NXnkUuEwga9ZjMwc9xH+xu6LVZXrkfHkss0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)