UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0AlBzcKNGo+yzoUyAIPQHeKmCmMz9mooV2yovZE06+E='
WHERE
key_id = 'b042d6e44e3405a3e35547da19d9ce3739a1b61c804d1031fb430f43c7efde63'
AND (
token = '0AlBzcKNGo+yzoUyAIPQHeKmCmMz9mooV2yovZE06+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)