UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9ew8IayXy6t5sz67pZx8dyuy5PirikVzc5rhCeTWC0='
WHERE
key_id = 'bc352ac67b1e0fb32b5e8c8234b52b046d226c603e4a3d7f2ed668aeb19d5c59'
AND (
token = 'U9ew8IayXy6t5sz67pZx8dyuy5PirikVzc5rhCeTWC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)