UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJppTxVbWsAO6FH1sQGibVP9HEKuwa3ukViF0+4/Oi4='
WHERE
key_id = '282bc603872733d4e6737d22331adf2a3bed6a508100f25711f4dbe15ee8a03a'
AND (
token = 'nJppTxVbWsAO6FH1sQGibVP9HEKuwa3ukViF0+4/Oi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)