UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8PQFMDcCJWZgjJiSAEwO7PXfr2A6VajgDgARuRu3Zg='
WHERE
key_id = 'acff9bed0d72185ecbd3a3a72faf95b5f7b9bb70aee78f04cb8b56f71cd14be1'
AND (
token = 'l8PQFMDcCJWZgjJiSAEwO7PXfr2A6VajgDgARuRu3Zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)