UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thYOZUjdywhPiLZ0/GzHtX1ueylKi80g8i/WS87+Yr0='
WHERE
key_id = 'd65eb7bd0e0689505ef19796a3191e7387c5fb5af8fecb5c0b66849cce909639'
AND (
token = 'thYOZUjdywhPiLZ0/GzHtX1ueylKi80g8i/WS87+Yr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)