UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3VHiSTGtohQenwC0ruxaPRicsIGVbKwnaQ7m3iuXz0='
WHERE
key_id = '87c46f0a84d0b76a29f6a6291ea0e90721f8087e1be2f2762197489074a06e69'
AND (
token = 'J3VHiSTGtohQenwC0ruxaPRicsIGVbKwnaQ7m3iuXz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)