UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WHRv+Gsn0F3oiHiDv3cFNwvzdsD8qcKF8pU+Jos5cIY=' 
WHERE 
  key_id = '04e706c5b67732ee34fe05ad9abd04aed54ce082ac1f1375d0b9de9b094cd157' 
  AND (
    token = 'WHRv+Gsn0F3oiHiDv3cFNwvzdsD8qcKF8pU+Jos5cIY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036