UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0R9KYXLu0flTwKs66KPqhBQo76Yr5vxyz3Str8J82ro='
WHERE
key_id = 'e0b74fc1f929108add8c675a31997591b4e6e4be6cbd386f22472af99549d496'
AND (
token = '0R9KYXLu0flTwKs66KPqhBQo76Yr5vxyz3Str8J82ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)