UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XANB/c0fZXK0vlbFh/yyeI/JqmWuwQEDh/9YtfPgQY8='
WHERE
key_id = 'f85ecb0b3932e91ee83d11bf14f58acd142c26bac63c34a8e8180012fa39e9f0'
AND (
token = 'XANB/c0fZXK0vlbFh/yyeI/JqmWuwQEDh/9YtfPgQY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)