UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgJAJAe1XNObao2Q+1md29uZgT5H37Pt96g2Nn+5jak='
WHERE
key_id = '9172af8219057620752472ba1d2b6dcff1e87859454ce97a2d1c83283ab8fe3e'
AND (
token = 'zgJAJAe1XNObao2Q+1md29uZgT5H37Pt96g2Nn+5jak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)