UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7pg93G6MvbcBhpaO47FOpO1ct8yECKV6atNrq1hY6I='
WHERE
key_id = '41afe99fdf44762434f9f7aab25f1f043637a7671c7b42fdca5206a1d6e02aff'
AND (
token = 'p7pg93G6MvbcBhpaO47FOpO1ct8yECKV6atNrq1hY6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)