UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hTJeMbDfe9MpNeNJ73Jbd4B/MVqfhh7mhFaXth5scww='
WHERE
key_id = '068ae03fe6668a88a49a888bb7518115d0d1c7edf2d24d14fd2a84bf77490f46'
AND (
token = 'hTJeMbDfe9MpNeNJ73Jbd4B/MVqfhh7mhFaXth5scww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)