UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'A4qDy/1dG8Cy7a2IYuu/J4qMxZ+pWC12/5D6lvnSAOg=' 
WHERE 
  key_id = '41ead66835e0d734f1401efa6fe0143879a7cc5f8dab54496b142626722046f9' 
  AND (
    token = 'A4qDy/1dG8Cy7a2IYuu/J4qMxZ+pWC12/5D6lvnSAOg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026