UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THKo9Kd49fY8z53eoyedCznUXc08CUnDZ8TvzBbFv6c='
WHERE
key_id = 'a457aa7098f651b49b277d9635b5f38f593bb4ee2f1a6749bca563dbc7cfb703'
AND (
token = 'THKo9Kd49fY8z53eoyedCznUXc08CUnDZ8TvzBbFv6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)