UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKZ07fgkPRyP/spSDW1qk+mOwXwNcmcUD8/m+y8cqSU='
WHERE
key_id = 'cc00661c74740589fc51b6da9bb101e47cd229d4b7806def20f01cc92e61d318'
AND (
token = 'cKZ07fgkPRyP/spSDW1qk+mOwXwNcmcUD8/m+y8cqSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)