UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47ttnVXE9wozT5mz3oykqFZjEEcA8ksxIixKkZ4zHYc='
WHERE
key_id = 'b388d6fa11a42bc3c976046cd3f189d786750dfbb4cc45c1820fd85c872c5654'
AND (
token = '47ttnVXE9wozT5mz3oykqFZjEEcA8ksxIixKkZ4zHYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)