UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'txm3QFI7lMjJT5LcTgHUs55cwcEW8Edf2NYmOyd3ej4='
WHERE
key_id = '46e12f804a5043dc07f17ca35fe979896d480649eb1e06265cc2ce3898cde50f'
AND (
token = 'txm3QFI7lMjJT5LcTgHUs55cwcEW8Edf2NYmOyd3ej4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)