UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNSwVkZq2NQFonq9n6JoGXad/hSHo3ZvP+7q+CrinA0='
WHERE
key_id = '74dddf76298b549a158e97903f2e4f43ce2d3c1010a370e332be0e6f7c5ad7de'
AND (
token = 'KNSwVkZq2NQFonq9n6JoGXad/hSHo3ZvP+7q+CrinA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)