UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UyNzcT46hBxvfHAjZJCik4jollsYaCXLlXGEXc8rzPA='
WHERE
key_id = '1a8b850e4b410c82bf22938d6f348bc34e3527f9fdec60ac361fbe501e28d234'
AND (
token = 'UyNzcT46hBxvfHAjZJCik4jollsYaCXLlXGEXc8rzPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)