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