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