UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HdB5Nd9p8XYVqZcVrFmyowvI5+I3MjoNkl8vCw2pro4='
WHERE
key_id = 'a6b05b89aa21e6acb98e00062549d59bfc21309cefa1734f8888ad7fe75a4b68'
AND (
token = 'HdB5Nd9p8XYVqZcVrFmyowvI5+I3MjoNkl8vCw2pro4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)