UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tdBYbdZNydxjgo8E64SDdHHijYraj1fv8dVQErWeBU4='
WHERE
key_id = '065ff911f6be733132e97c7bd4f3c170305859cafc442a3218d615afc2c96d25'
AND (
token = 'tdBYbdZNydxjgo8E64SDdHHijYraj1fv8dVQErWeBU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)