UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '165h6rvTGdNKMXcAG/9a7sr+maD8p5erNnThETfcDbk='
WHERE
key_id = '5394483794abbf8fc954b00a84b05afea9989ff6af52c68edd650837d2caf66b'
AND (
token = '165h6rvTGdNKMXcAG/9a7sr+maD8p5erNnThETfcDbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)