UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yHMlluTLeKAARZ6a7W9AlTvl6HeOb4CNsj5b1vxEwAw='
WHERE
key_id = '393d65633a2ed4f0e4aedbbf9731a35090cc59a2fff7501add462304da2912e3'
AND (
token = 'yHMlluTLeKAARZ6a7W9AlTvl6HeOb4CNsj5b1vxEwAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)