UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZTaYKjsFp51/o7k6etbywB9SGNkszRGfR3yLC61BGs='
WHERE
key_id = '7c1cec5fb36b5d17e401b6463636a44488f490e9e55ec858799eee2a59ee0872'
AND (
token = '6ZTaYKjsFp51/o7k6etbywB9SGNkszRGfR3yLC61BGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)