UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nvIvtC7wOebNHlEUItWF+/pM2NIUwzKPO45xeO1QbQs='
WHERE
key_id = '2dea1b5db9bcc7c8b1d84ecdf4be8e000fd744e19de6734b8397f2a980363993'
AND (
token = 'nvIvtC7wOebNHlEUItWF+/pM2NIUwzKPO45xeO1QbQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)