UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VznyfYxvP+1IKYa0T+9jj1D9T9cEL6nfP6SoiqOALWM='
WHERE
key_id = 'c6e580650dc8812126cf75289ac0b2eef6eb8af2e2414056b0c6e4c6fbfb4266'
AND (
token = 'VznyfYxvP+1IKYa0T+9jj1D9T9cEL6nfP6SoiqOALWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)