UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7smUJqbgfc0XEeDo0YYgiXH5GkaaDXAchddt9yA87zI='
WHERE
key_id = '9883b9b31c8a68153fc952c57a385dad0d7ef5c5f42d07992f02917d53e525ff'
AND (
token = '7smUJqbgfc0XEeDo0YYgiXH5GkaaDXAchddt9yA87zI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)