UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhlKAc9SoN3hDhDgjiSaKRn2BAGUd8z/v8y4qGkW3cc='
WHERE
key_id = 'd4f6919571f44ff5947d549cdfe6cfccaa54c62919ae87666c3d71fbd9d8aa80'
AND (
token = 'BhlKAc9SoN3hDhDgjiSaKRn2BAGUd8z/v8y4qGkW3cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)