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