UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9i+vYVC+dqqgGs5wF1wbx9bq9axmocCK09Fh/pR114='
WHERE
key_id = '7a6071b535fc91ca8f46eb14d9d623522432a32918284d14b6ece30137f6a812'
AND (
token = 'E9i+vYVC+dqqgGs5wF1wbx9bq9axmocCK09Fh/pR114='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)