UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXfUcP9OA97P4OG1v4wBTn2sEBufsExKAtqDQPMbiyI='
WHERE
key_id = '8d39980b191c4e029b58d39b0b1d5c558f20eec4ec856380b3da122d80998f41'
AND (
token = 'KXfUcP9OA97P4OG1v4wBTn2sEBufsExKAtqDQPMbiyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)