UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tncnXRkrxP4TIK+9nWt36NRsWGe+McRtXKdf+Km+gK0='
WHERE
key_id = '9067a15ac786c4f4a11b1038baa7c8809e5dfbd02fe5e741886e8704579f760f'
AND (
token = 'tncnXRkrxP4TIK+9nWt36NRsWGe+McRtXKdf+Km+gK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)