UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZnLtCZDA10U/qYiL5aEOpoRhNnL6f0g1t94tXIziSE='
WHERE
key_id = '7ad927ca79626bce1995d3c2f83b5589219c2692f4047e8a3f08925cd2532b9d'
AND (
token = 'hZnLtCZDA10U/qYiL5aEOpoRhNnL6f0g1t94tXIziSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)